package com.example.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.example.entity.PaymentInfo;
import org.apache.ibatis.annotations.Select;
import org.springframework.web.bind.annotation.RequestParam;

/**
* @author circle48
* @description 针对表【payment_info(支付信息表)】的数据库操作Mapper
* @createDate 2024-06-06 20:13:04
* @Entity com.example.entity.PaymentInfo
*/
public interface PaymentInfoMapper extends BaseMapper<PaymentInfo> {

    @Select("select * from payment_info where alipay_trade_no=#{trade_no}")
    PaymentInfo findByAlipayTradeNo(@RequestParam("trade_no") String trade_no);

    @Select("select order_ids from payment_info where alipay_trade_no=#{trade_no}")
    String getOrderIds(String out_trade_no);
}




